Wrapping CrossJoin

 

Let us suppose we have MDX command with one hierarchy hCustomer inside row axis and we would like

to have another one hProduct. Basically we would like to create CrossJoin of two hierarchies.

 

 

To do that you can write it manually around hCustomer  or you can use intellisense for that operation

 

§          select part of the command that will be one set inside CrossJoin function

o         if you select from bottom up (from row 12 up to row 10) then your selected set will be second

inside function and you will insert hProduct on first place inside function

 

o         if you select from top down (from row 10 up to row 12) then your selected set will be first

inside function and you will insert hProduct on second place inside function

 

§          now start typing "cro" for crossJoin

§          press ENTER

 

 

BOTTOM-UP                                                                                      TOP-DOWN

 

           

 

Type "cro"

 

 

press ENTER

 

BOTTOM-UP                                                                                      TOP-DOWN